﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Ventas.aspx.vb" Inherits="Libreria.Formulario_web12" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
    .style1
    {
        width: 100%;
    }
    .style2
    {
    }
    .style4
    {
        width: 43px;
    }
    .style5
    {
        width: 138px;
    }
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <table class="style1">
    <tr>
        <td class="style4">
            Ventas</td>
        <td class="style5">
            <asp:TextBox ID="TextBox1" runat="server" Width="197px"></asp:TextBox>
        </td>
        <td>
            <input id="Button1" type="button" value="Buscar" /></td>
        <td>
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style2" colspan="3" rowspan="2">
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                DataKeyNames="stor_id,ord_num,title_id" DataSourceID="SqlDataSource1">
                <Columns>
                    <asp:BoundField DataField="stor_id" HeaderText="stor_id" ReadOnly="True" 
                        SortExpression="stor_id" />
                    <asp:BoundField DataField="ord_num" HeaderText="ord_num" ReadOnly="True" 
                        SortExpression="ord_num" />
                    <asp:BoundField DataField="ord_date" HeaderText="ord_date" 
                        SortExpression="ord_date" />
                    <asp:BoundField DataField="qty" HeaderText="qty" SortExpression="qty" />
                    <asp:BoundField DataField="payterms" HeaderText="payterms" 
                        SortExpression="payterms" />
                    <asp:BoundField DataField="title_id" HeaderText="title_id" ReadOnly="True" 
                        SortExpression="title_id" />
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                ConnectionString="<%$ ConnectionStrings:pubsConnectionString9 %>" 
                SelectCommand="SELECT * FROM [sales] WHERE ([ord_num] = @ord_num)">
                <SelectParameters>
                    <asp:ControlParameter ControlID="TextBox1" Name="ord_num" PropertyName="Text" 
                        Type="String" />
                </SelectParameters>
            </asp:SqlDataSource>
        </td>
        <td>
            &nbsp;</td>
    </tr>
    <tr>
        <td>
            &nbsp;</td>
    </tr>
</table>
</asp:Content>
